﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="GazOnDevDataSetAccompanying_stocks" targetNamespace="http://tempuri.org/GazOnDevDataSetAccompanying_stocks.xsd" xmlns:mstns="http://tempuri.org/GazOnDevDataSetAccompanying_stocks.xsd" xmlns="http://tempuri.org/GazOnDevDataSetAccompanying_stocks.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="GazOnConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="GazOnConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.GazOnConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Accompanying_stocksTableAdapter" GeneratorDataComponentClassName="Accompanying_stocksTableAdapter" Name="Accompanying_stocks" UserDataComponentName="Accompanying_stocksTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GazOnConnectionString (Web.config)" DbObjectName="GazOnDev.dbo.Accompanying_stocks" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Accompanying_stocks] WHERE (([Id] = @Original_Id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Accompanying_stocks] ([Title], [Count], [makat], [isininvoice], [invoiceorder], [Unit], [cteatedby]) VALUES (@Title, @Count, @makat, @isininvoice, @invoiceorder, @Unit, @cteatedby)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Count" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Count" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@makat" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="makat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isininvoice" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isininvoice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@invoiceorder" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="invoiceorder" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Unit" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Unit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cteatedby" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cteatedby" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, Title, Count, makat, isininvoice, invoiceorder, Unit, cteatedby FROM dbo.Accompanying_stocks</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Accompanying_stocks] SET [Title] = @Title, [Count] = @Count, [makat] = @makat, [isininvoice] = @isininvoice, [invoiceorder] = @invoiceorder, [Unit] = @Unit, [cteatedby] = @cteatedby WHERE (([Id] = @Original_Id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Count" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Count" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@makat" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="makat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isininvoice" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isininvoice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@invoiceorder" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="invoiceorder" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Unit" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Unit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cteatedby" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cteatedby" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
              <Mapping SourceColumn="Count" DataSetColumn="Count" />
              <Mapping SourceColumn="makat" DataSetColumn="makat" />
              <Mapping SourceColumn="isininvoice" DataSetColumn="isininvoice" />
              <Mapping SourceColumn="invoiceorder" DataSetColumn="invoiceorder" />
              <Mapping SourceColumn="Unit" DataSetColumn="Unit" />
              <Mapping SourceColumn="cteatedby" DataSetColumn="cteatedby" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Accompanying_stocks_logTableAdapter" GeneratorDataComponentClassName="Accompanying_stocks_logTableAdapter" Name="Accompanying_stocks_log" UserDataComponentName="Accompanying_stocks_logTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="GazOnConnectionString (Web.config)" DbObjectName="GazOnDev.dbo.Accompanying_stocks_log" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Accompanying_stocks_log] WHERE (([Id] = @Original_Id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Accompanying_stocks_log] ([Title], [Count], [makat], [isininvoice], [invoiceorder], [Unit], [date], [invoicenumber], [supplier], [stockitemid], [cteatedby]) VALUES (@Title, @Count, @makat, @isininvoice, @invoiceorder, @Unit, @date, @invoicenumber, @supplier, @stockitemid, @cteatedby)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Count" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Count" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@makat" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="makat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isininvoice" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isininvoice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@invoiceorder" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="invoiceorder" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Unit" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Unit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@date" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@invoicenumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="invoicenumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@supplier" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="supplier" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@stockitemid" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="stockitemid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cteatedby" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cteatedby" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, Title, Count, makat, isininvoice, invoiceorder, Unit, date, invoicenumber, supplier, stockitemid, cteatedby FROM dbo.Accompanying_stocks_log</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Accompanying_stocks_log] SET [Title] = @Title, [Count] = @Count, [makat] = @makat, [isininvoice] = @isininvoice, [invoiceorder] = @invoiceorder, [Unit] = @Unit, [date] = @date, [invoicenumber] = @invoicenumber, [supplier] = @supplier, [stockitemid] = @stockitemid, [cteatedby] = @cteatedby WHERE (([Id] = @Original_Id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Count" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Count" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@makat" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="makat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isininvoice" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isininvoice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@invoiceorder" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="invoiceorder" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Unit" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Unit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@date" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@invoicenumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="invoicenumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@supplier" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="supplier" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@stockitemid" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="stockitemid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cteatedby" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cteatedby" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
              <Mapping SourceColumn="Count" DataSetColumn="Count" />
              <Mapping SourceColumn="makat" DataSetColumn="makat" />
              <Mapping SourceColumn="isininvoice" DataSetColumn="isininvoice" />
              <Mapping SourceColumn="invoiceorder" DataSetColumn="invoiceorder" />
              <Mapping SourceColumn="Unit" DataSetColumn="Unit" />
              <Mapping SourceColumn="date" DataSetColumn="date" />
              <Mapping SourceColumn="invoicenumber" DataSetColumn="invoicenumber" />
              <Mapping SourceColumn="supplier" DataSetColumn="supplier" />
              <Mapping SourceColumn="stockitemid" DataSetColumn="stockitemid" />
              <Mapping SourceColumn="cteatedby" DataSetColumn="cteatedby" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="GazOnDevDataSetAccompanying_stocks" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="GazOnDevDataSetAccompanying_stocks" msprop:Generator_UserDSName="GazOnDevDataSetAccompanying_stocks">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Accompanying_stocks" msprop:Generator_TableClassName="Accompanying_stocksDataTable" msprop:Generator_TableVarName="tableAccompanying_stocks" msprop:Generator_TablePropName="Accompanying_stocks" msprop:Generator_RowDeletingName="Accompanying_stocksRowDeleting" msprop:Generator_RowChangingName="Accompanying_stocksRowChanging" msprop:Generator_RowEvHandlerName="Accompanying_stocksRowChangeEventHandler" msprop:Generator_RowDeletedName="Accompanying_stocksRowDeleted" msprop:Generator_UserTableName="Accompanying_stocks" msprop:Generator_RowChangedName="Accompanying_stocksRowChanged" msprop:Generator_RowEvArgName="Accompanying_stocksRowChangeEvent" msprop:Generator_RowClassName="Accompanying_stocksRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_UserColumnName="Title">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Count" msprop:Generator_ColumnVarNameInTable="columnCount" msprop:Generator_ColumnPropNameInRow="Count" msprop:Generator_ColumnPropNameInTable="CountColumn" msprop:Generator_UserColumnName="Count">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="makat" msprop:Generator_ColumnVarNameInTable="columnmakat" msprop:Generator_ColumnPropNameInRow="makat" msprop:Generator_ColumnPropNameInTable="makatColumn" msprop:Generator_UserColumnName="makat" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="isininvoice" msprop:Generator_ColumnVarNameInTable="columnisininvoice" msprop:Generator_ColumnPropNameInRow="isininvoice" msprop:Generator_ColumnPropNameInTable="isininvoiceColumn" msprop:Generator_UserColumnName="isininvoice" type="xs:boolean" minOccurs="0" />
              <xs:element name="invoiceorder" msprop:Generator_ColumnVarNameInTable="columninvoiceorder" msprop:Generator_ColumnPropNameInRow="invoiceorder" msprop:Generator_ColumnPropNameInTable="invoiceorderColumn" msprop:Generator_UserColumnName="invoiceorder" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Unit" msprop:Generator_ColumnVarNameInTable="columnUnit" msprop:Generator_ColumnPropNameInRow="Unit" msprop:Generator_ColumnPropNameInTable="UnitColumn" msprop:Generator_UserColumnName="Unit" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cteatedby" msprop:Generator_ColumnVarNameInTable="columncteatedby" msprop:Generator_ColumnPropNameInRow="cteatedby" msprop:Generator_ColumnPropNameInTable="cteatedbyColumn" msprop:Generator_UserColumnName="cteatedby" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Accompanying_stocks_log" msprop:Generator_TableClassName="Accompanying_stocks_logDataTable" msprop:Generator_TableVarName="tableAccompanying_stocks_log" msprop:Generator_TablePropName="Accompanying_stocks_log" msprop:Generator_RowDeletingName="Accompanying_stocks_logRowDeleting" msprop:Generator_RowChangingName="Accompanying_stocks_logRowChanging" msprop:Generator_RowEvHandlerName="Accompanying_stocks_logRowChangeEventHandler" msprop:Generator_RowDeletedName="Accompanying_stocks_logRowDeleted" msprop:Generator_UserTableName="Accompanying_stocks_log" msprop:Generator_RowChangedName="Accompanying_stocks_logRowChanged" msprop:Generator_RowEvArgName="Accompanying_stocks_logRowChangeEvent" msprop:Generator_RowClassName="Accompanying_stocks_logRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_UserColumnName="Title">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Count" msprop:Generator_ColumnVarNameInTable="columnCount" msprop:Generator_ColumnPropNameInRow="Count" msprop:Generator_ColumnPropNameInTable="CountColumn" msprop:Generator_UserColumnName="Count">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="makat" msprop:Generator_ColumnVarNameInTable="columnmakat" msprop:Generator_ColumnPropNameInRow="makat" msprop:Generator_ColumnPropNameInTable="makatColumn" msprop:Generator_UserColumnName="makat" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="isininvoice" msprop:Generator_ColumnVarNameInTable="columnisininvoice" msprop:Generator_ColumnPropNameInRow="isininvoice" msprop:Generator_ColumnPropNameInTable="isininvoiceColumn" msprop:Generator_UserColumnName="isininvoice" type="xs:boolean" minOccurs="0" />
              <xs:element name="invoiceorder" msprop:Generator_ColumnVarNameInTable="columninvoiceorder" msprop:Generator_ColumnPropNameInRow="invoiceorder" msprop:Generator_ColumnPropNameInTable="invoiceorderColumn" msprop:Generator_UserColumnName="invoiceorder" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Unit" msprop:Generator_ColumnVarNameInTable="columnUnit" msprop:Generator_ColumnPropNameInRow="Unit" msprop:Generator_ColumnPropNameInTable="UnitColumn" msprop:Generator_UserColumnName="Unit" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="date" msprop:Generator_ColumnVarNameInTable="columndate" msprop:Generator_ColumnPropNameInRow="date" msprop:Generator_ColumnPropNameInTable="dateColumn" msprop:Generator_UserColumnName="date" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="invoicenumber" msprop:Generator_ColumnVarNameInTable="columninvoicenumber" msprop:Generator_ColumnPropNameInRow="invoicenumber" msprop:Generator_ColumnPropNameInTable="invoicenumberColumn" msprop:Generator_UserColumnName="invoicenumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="supplier" msprop:Generator_ColumnVarNameInTable="columnsupplier" msprop:Generator_ColumnPropNameInRow="supplier" msprop:Generator_ColumnPropNameInTable="supplierColumn" msprop:Generator_UserColumnName="supplier" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="stockitemid" msprop:Generator_ColumnVarNameInTable="columnstockitemid" msprop:Generator_ColumnPropNameInRow="stockitemid" msprop:Generator_ColumnPropNameInTable="stockitemidColumn" msprop:Generator_UserColumnName="stockitemid" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cteatedby" msprop:Generator_ColumnVarNameInTable="columncteatedby" msprop:Generator_ColumnPropNameInRow="cteatedby" msprop:Generator_ColumnPropNameInTable="cteatedbyColumn" msprop:Generator_UserColumnName="cteatedby" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Accompanying_stocks" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Accompanying_stocks_log_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Accompanying_stocks_log" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
  </xs:element>
</xs:schema>